Release 10.1A: OpenEdge Data Management:
Database Administration

Archive log file

The AI File Management Utility creates a log of the extents it archives. The log file is written to the same directory as your database .db file, and is named, database-name.archival.log. The log file is created the first time an extent is archived. The information stored in the archive log file provides details of when the AI file management utility was started, and extent archiving activity that you can use to develop either an automated or manual recovery a database.

Each time the AI File Management daemon is started, two lines are written to the archive to record the data and time. It is formatted as follows:

# After-image Extent Manager started on : Tuesday October 11, 2005 at 10:02:25 # 0255,20051011,100225,100100

In the second line of the example above provides version and startup information and is formatted as follows:

# 0255, date, time, release

Table 7–2: Format of an archival log startup line

Field	Value
Version indicator (0255)	Version line indicator.
date	Date the Extent Manager started in YYYYMMDD format.
time	Time the Extent Manager started in HHMMSS format.

After the header lines, each line of the file describes an archive event with a comma separated list of details. An archive line is formatted as follows:

0001,database,date,time,buseq,aibegin-date,aibegin-time,aiseq,extent-name,       target-directory,target-extent-name

Table 7–3 describes each element of an AI extent archive line.

Table 7–3: Format of an archive log file AI extent archive line 

Field	Value
Extent Archive indicator (0001)	AI extent archive indicator.
database	Name of the database.
date	Date of the backup in YYYYMMDD format.
time	Time of the backup in HHMMSSUUU format.
buseq	Backup sequence number of the backup.
aibegin-date	Date that after imaging was started for the database in YYYYMMDD format.
aibegin-time	Date that after imaging was started for the database in HHMMSSUUU format.
aiseq	AI extent sequence number, with leading zeros
extent-name	Source name of the archived extent.
target-directory	The directory where the extent is archived.
target-extent-name	The file name of archived extent.